package com.im.foodorderingsystem.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class FOSDB extends SQLiteOpenHelper{

	private static final String FOS_DB_NAME = "fosdb";
	public static final int DB_VERSION=2;
	public static final String CATEGORY_TABLE_NAME="category";
	
	public static final String CATEGORY_CREATE="CREATE TABLE "+CATEGORY_TABLE_NAME+
			"(category_id INTEGER PRIMARY KEY,name TEXT,available TEXT,deleted TEXT)";
	
	public FOSDB(Context context) {
		super(context, FOS_DB_NAME, null, DB_VERSION);
		System.out.println("constructure");
		// TODO Auto-generated constructor stub
		
	}

	
	//private static final String CATEGORY = "Info";
	

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CATEGORY_CREATE);
		//System.out.println("create NOTES_CREATE");
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		// TODO Auto-generated method stub
		
	}
	
	
}
